<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0 Transitional//EN'><html>
<head>
<title>Database documentation</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF8"/>
<style type='text/css'>
	 #dbs {font-family:Tahoma,Dialog,Sans-Serif;font-size:11px;background:#fff;width:80%;border-collapse:collapse;text-align:left;margin:20px;}
	 #dbs thead{background:#ddd;}
	 #dbs th{font-size:12px;font-weight:bold;color:#336;border-bottom:2px solid #336;padding:7px 8px;}
	 #dbs td{border-bottom:1px solid #ccc;color:#336;padding:3px 8px;white-space: pre;}
	 td.subpart{font-weight:bold;background:#ddd}
	 td.name{background:#f2f2f2}
	 #dbs tbody tr:hover td{color:#000;background:#fffcea;}
</style>
</head>

<body>
<object data='fpost_schema.svg' width='896' height='778' type='image/svg+xml' >
<embed src='fpost_schema.svg' width='896' height='778' type='image/svg+xml' />
<p>The <a href="http://www.adobe.com/svg/viewer/install/main.html">Adobe SVG Viewer</a> is required to view this image !</p></object>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='ARTICLE'>ARTICLE</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='ARTICLE_ID'>ARTICLE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='DELETED'>DELETED</a></td>
		<td width='40%'> CHAR&#040; 1 &#041;    NOT NULL    DEFO 0 </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='HIT_COUNT'>HIT&#095;COUNT</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='IN_DICTIONARY'>IN&#095;DICTIONARY</a></td>
		<td width='40%'> CHAR&#040; 1 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='USER_ID'>USER&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>INDX&#095;USER&#095;ID </td>
		<td> ( USER&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;ARTICLE primary key</td>
		<td> ( ARTICLE&#095;ID) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>FK_USER</td>
		<td > (  USER&#095;ID  ) ref <a href='#FPUSER'>FPUSER</a> ( USER&#095;ID ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='ARTICLE_COMMENT'>ARTICLE_COMMENT</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='ARTICLE_COMMENT_ID'>ARTICLE&#095;COMMENT&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_COMMENT'>ARTICLE&#095;COMMENT</a></td>
		<td width='40%'> NCLOB&#040; 4000 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_ID'>ARTICLE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_BY'>CREATED&#095;BY</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_IP'>CREATED&#095;IP</a></td>
		<td width='40%'> VARCHAR2&#040; 24 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_ON'>CREATED&#095;ON</a></td>
		<td width='40%'> TIMESTAMP    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>INDX&#095;COMMENT&#095;ARTICLE&#095;ID </td>
		<td> ( ARTICLE&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;ARTICLE&#095;COMMENT primary key</td>
		<td> ( ARTICLE&#095;COMMENT&#095;ID) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>FK_ARTICLE_COMMENT_ARTICLE</td>
		<td > (  ARTICLE&#095;ID  ) ref <a href='#ARTICLE'>ARTICLE</a> ( ARTICLE&#095;ID ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='ARTICLE_DICTIONARY'>ARTICLE_DICTIONARY</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='ARTICLE_DICTIONARY_ID'>ARTICLE&#095;DICTIONARY&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_ID'>ARTICLE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='DICTIONARY_ID'>DICTIONARY&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>ARTICLE&#095;DICTIONARY&#095;UNIQUE unique</td>
		<td> ( ARTICLE&#095;ID, DICTIONARY&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>INDX&#095;ART&#095;DICT&#095;DICTIONARY&#095;ID </td>
		<td> ( DICTIONARY&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;ART&#095;DICT&#095;ID primary key</td>
		<td> ( ARTICLE&#095;DICTIONARY&#095;ID) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>FK_ART_DICT_ARTICLE_ID</td>
		<td > (  ARTICLE&#095;ID  ) ref <a href='#ARTICLE'>ARTICLE</a> ( ARTICLE&#095;ID ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>FK_ART_DICT_DICTIONARY_ID</td>
		<td > (  DICTIONARY&#095;ID  ) ref <a href='#DICTIONARY'>DICTIONARY</a> ( DICTIONARY&#095;ID ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='ARTICLE_RATING'>ARTICLE_RATING</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='ARTICLE_RATING_ID'>ARTICLE&#095;RATING&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_ID'>ARTICLE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_BY'>CREATED&#095;BY</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_IP'>CREATED&#095;IP</a></td>
		<td width='40%'> VARCHAR2&#040; 24 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_ON'>CREATED&#095;ON</a></td>
		<td width='40%'> TIMESTAMP    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='RATING'>RATING</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>INDX&#095;ARTICLE&#095;RATING&#095;ARTICLE&#095;ID </td>
		<td> ( ARTICLE&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;ARTICLE&#095;RATING primary key</td>
		<td> ( ARTICLE&#095;RATING&#095;ID) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>FK_ARTICLE_RATING_ARTICLE</td>
		<td > (  ARTICLE&#095;ID  ) ref <a href='#ARTICLE'>ARTICLE</a> ( ARTICLE&#095;ID ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='ARTICLE_TYPE'>ARTICLE_TYPE</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='ARTICLE_TYPE_ID'>ARTICLE&#095;TYPE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_TYPE'>ARTICLE&#095;TYPE</a></td>
		<td width='40%'> VARCHAR2&#040; 1024 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>PK&#095;ARTICLE&#095;TYPE primary key</td>
		<td> ( ARTICLE&#095;TYPE&#095;ID) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='ARTICLE_VERSION'>ARTICLE_VERSION</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='ARTICLE_VERSION_ID'>ARTICLE&#095;VERSION&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_ID'>ARTICLE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_TYPE_ID'>ARTICLE&#095;TYPE&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='BODY'>BODY</a></td>
		<td width='40%'> NCLOB&#040; 4000 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_IP'>CREATED&#095;IP</a></td>
		<td width='40%'> VARCHAR2&#040; 24 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_ON'>CREATED&#095;ON</a></td>
		<td width='40%'> TIMESTAMP    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='DELETED'>DELETED</a></td>
		<td width='40%'> CHAR&#040; 1 &#041;    NOT NULL    DEFO 0 </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='HIT_COUNT'>HIT&#095;COUNT</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='KEYWORDS'>KEYWORDS</a></td>
		<td width='40%'> NVARCHAR2&#040; 1000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LATEST_VERSION'>LATEST&#095;VERSION</a></td>
		<td width='40%'> CHAR&#040; 1 &#041;    NOT NULL    DEFO 'Y' </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='SUMMARY'>SUMMARY</a></td>
		<td width='40%'> NCLOB&#040; 4000 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='TITLE'>TITLE</a></td>
		<td width='40%'> NVARCHAR2&#040; 1000 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>INDX&#095;ARTICLE&#095;ID </td>
		<td> ( ARTICLE&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>INDX&#095;ARTICLE&#095;TYPE&#095;ID </td>
		<td> ( ARTICLE&#095;TYPE&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;ARTICLE&#095;VERSION primary key</td>
		<td> ( ARTICLE&#095;VERSION&#095;ID) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>FK_ARTICLE</td>
		<td > (  ARTICLE&#095;ID  ) ref <a href='#ARTICLE'>ARTICLE</a> ( ARTICLE&#095;ID ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>FK_ARTICLE_TYPE</td>
		<td > (  ARTICLE&#095;TYPE&#095;ID  ) ref <a href='#ARTICLE&#095;TYPE'>ARTICLE&#095;TYPE</a> ( ARTICLE&#095;TYPE&#095;ID ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='DICTIONARY'>DICTIONARY</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='DICTIONARY_ID'>DICTIONARY&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ENTRY'>ENTRY</a></td>
		<td width='40%'> NVARCHAR2&#040; 48 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>DICTIONARY&#095;UNIQUE unique</td>
		<td> ( ENTRY) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;DICTIONARY&#095;ID primary key</td>
		<td> ( DICTIONARY&#095;ID) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='FPUSER'>FPUSER</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='USER_ID'>USER&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_ON'>CREATED&#095;ON</a></td>
		<td width='40%'> TIMESTAMP     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='EMAIL_ADDRESS'>EMAIL&#095;ADDRESS</a></td>
		<td width='40%'> VARCHAR2&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='FIRST_NAME'>FIRST&#095;NAME</a></td>
		<td width='40%'> VARCHAR2&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LAST_NAME'>LAST&#095;NAME</a></td>
		<td width='40%'> VARCHAR2&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER&#040; 38 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='MODIFIED_ON'>MODIFIED&#095;ON</a></td>
		<td width='40%'> TIMESTAMP     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='PASSWORD'>PASSWORD</a></td>
		<td width='40%'> VARCHAR2&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='USERNAME'>USERNAME</a></td>
		<td width='40%'> VARCHAR2&#040; 1024 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>PK&#095;FPUSER primary key</td>
		<td> ( USER&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>USER&#095;NAME&#095;UNIQUE unique</td>
		<td> ( USERNAME) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='IP'>IP</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='IP_ID'>IP&#095;ID</a></td>
		<td width='40%'> NUMBER    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ARTICLE_ID'>ARTICLE&#095;ID</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_BY'>CREATED&#095;BY</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='CREATED_ON'>CREATED&#095;ON</a></td>
		<td width='40%'> TIMESTAMP    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='IP_ADDRESS'>IP&#095;ADDRESS</a></td>
		<td width='40%'> VARCHAR2&#040; 24 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='LOCK_SEQ_NUM'>LOCK&#095;SEQ&#095;NUM</a></td>
		<td width='40%'> NUMBER     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='URI'>URI</a></td>
		<td width='40%'> VARCHAR2&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>INDX&#095;IP&#095;ARTICLE&#095;ID </td>
		<td> ( ARTICLE&#095;ID) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>PK&#095;IP primary key</td>
		<td> ( IP&#095;ID) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>FK_IP_ARTICLE</td>
		<td > (  ARTICLE&#095;ID  ) ref <a href='#ARTICLE'>ARTICLE</a> ( ARTICLE&#095;ID ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

</body></html>